Towards Model-based Management of Database Fragmentation
نویسندگان
چکیده
The performance of a database can significantly deteriorate due to the fragmentation of data/index files. Manual database defragmentation and performance optimization remain time consuming and even infeasible as it requires knowledge of the complicated behavior of fragmentation and its relationships with system parameters. We propose a model-based detection and management framework for the database fragmentation which can automatically optimize database performance, detect the fault existence, estimate its future impact on system performance and recover the system back to normal. A predictive controller is designed to take proper actions to guarantee the QoS and remedy faults. Experimental studies on a realistic test-bed show the applicability and effectiveness of our approach.
منابع مشابه
A Knowledge-Based Perspective of the Distributed Design of Object Oriented Databases
The performance of applications on Object Oriented Database Management Systems (OODBMSs) is strongly affected by Distributed Design, which reduces irrelevant data accessed by applications and data exchange among sites. In an OO environment, the Distributed Design is a very complex task, and an open research problem. In this work we propose a knowledge based approach to the fragmentation phase o...
متن کاملHorizontal Fragmentation in Object DBMS: New Issues and Performance Evaluation
Horizontal fragmentation may improve the performance of database systems. Defining primary and derived horizontal fragmentation along the classes in a database schema is an important and complex issue, yet not discussed in the literature, which must be considered when horizontally fragmenting a database. In this paper, we focus on an analysis to help the designer upon the decision for primary o...
متن کاملPrediction of fragmentation due to blasting using mutual information and rock engineering system; case study: Meydook copper mine
One of the key outcomes of blasting in mines is found to be rock fragmentation which profoundly affects downstream expenses. In fact, size prediction of rock fragmentation is the first leap towards the optimization of blasting design parameters. This paper makes an attempt to present a model to predict rock fragmentation using Mutual Information (MI) in Meydook copper mine. Ten parameters are c...
متن کاملA Mixed Fragmentation Algorithm for Distributed Object Oriented Databases
The performance of applications on Object Oriented Database Management Systems (OODBMSs) is strongly affected by Distributed Design, which reduces irrelevant data accessed by applications and data exchange among sites. This work proposes an algorithm to the fragmentation phase of the distributed design of object oriented databases, according to a set of heuristics obtained from experimental res...
متن کاملA Comparative Study of Horizontal Object Clustering-based Fragmentation Techniques
Design of modern Distributed Object Oriented Databases (DOODs) requires class fragmentation techniques. Although research has been conducted in this area, most of the developed methods are inspired from the relational fragmentation algorithms. In this paper we develop a comparative approach of two new methods for horizontal class fragmentation in a DOOD. These methods rely on two AI clustering ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2013